CREATE TABLE tb_Hole(
	HoleId INT NOT NULL IDENTITY(1, 1),
	CourseId INT NOT NULL,
	Ordinal INT NOT NULL,
	Yardage INT NOT NULL,
	Par INT NOT NULL,
	CONSTRAINT PK_Hole PRIMARY KEY (HoleId),
	CONSTRAINT FK_Hole_Course FOREIGN KEY (CourseId)
		REFERENCES tb_Course (CourseId),
	CONSTRAINT UQ_Hole_Course_Ordinal UNIQUE (CourseId, Ordinal))